<?php
echo("<br> test.php");
require_once APPLICATION_ROOT.'/authority/file_xls/Excel/reader.php';

// ExcelFile($filename, $encoding);
$data = new Spreadsheet_Excel_Reader();

// Set output Encoding.
$data->setOutputEncoding('CP1251');

/***
* if you want you can change 'iconv' to mb_convert_encoding:
* $data->setUTFEncoder('mb');
*
**/

/***
* By default rows & cols indeces start with 1
* For change initial index use:
* $data->setRowColOffset(0);
*
**/

/***
*  Some function for formatting output.
* $data->setDefaultFormat('%.2f');
* setDefaultFormat - set format for columns with unknown formatting
*
* $data->setColumnFormat(4, '%.3f');
* setColumnFormat - set format for column (apply only to number fields)
*
**/

//require_once(APPLICATION_ROOT."/oracleaccess/classes/DbConnect.php" );

$data->read(APPLICATION_ROOT.'/authority/file_xls/ANAS.xls'); //C:\xampp\htdocs\anas\authority\file_xls\leggi_xls.php

require_once(APPLICATION_ROOT."/oracleaccess/classes/DbConnect.php" );
$connessione = new DbConnect();
//echo "\"".$data->sheets[0]['cells'][3]3]."\",";

 /*for ($j = 1; $j <= $data->sheets[0]['numCols']; $j++) 
  {
    echo "\"".$data->sheets[0]['cells'][$i][$j]."\",";
    
  }
  */
exit();
?>